const userModel = {
  checkByUsername: 'select * from user where account = ?',
  list: 'SELECT planting_area.*, GROUP_CONCAT(planting_area_tree.planting_tree_id) AS planting_area_tree_id_array FROM planting_area LEFT JOIN planting_area_tree ON planting_area.id = planting_area_tree.planting_area_id GROUP BY planting_area.id ORDER BY planting_area.sort DESC, planting_area.created_at DESC LIMIT 10 OFFSET 0',
  pageList: 'select * from user',
  addUser: 'insert into ev_users set ?'
}

module.exports = userModel
